fort monroe

Interfund Bill Process

TRADOC SSF Conference
February 6-7, 2001
Presented by: Mary Kemp

AGENDA

• P rocess Flow
- IF

• Staffing

INTERFUND BILL
PROCESS

Retrieve
FD2 Froir
DAAS

Edit -

m i

L EC

1st Thing Each AM

A

X

Interfund

Bills

DAAS

Normally Pull Bills in AM
FTP by COB

FTP ^

STANFINS

Sep 28, 2000

Is there a better way?

Meet 1-2 day turn
around time

Reduce manual
work

Eliminate risk of

duplicate

payments

« 0 5 II

Microsoft Access - [I BO MF : Form]

[H File Edit View Insert Format Records lools Window Help MAINTAIN REPORTS IBO FORMS IMPORT STANFINS - |fl| x|

BRAGG

1

LEWIS

1

MEADE

CAMPBELL

1

WEST POINT |

1

1

JACKSON

STEWART

LEAVENWORTH |

BELVOIR

Start

| ^ Microsoft Excel |

^Welcome to T...|

Welcome to T...| ^Microsoft...

o'

o

o

?

o

Q_

| [^Microsoft Pow...|

Microsoft Access - [Processing : Form]

[H File Edit View Insert Format Records lools Window Help MAINTAIN REPORTS IBO FORMS IMPORT STANFINS

l-l*H

# H - §1 Exit «o & ^ M ◄ ► NgA^ a V Ih Filter Excluding Selection ^

INTERFUND PROCESSING

ii

REVIEW DETAIL

■Wiiiirra iiFIV i Vintr ■ IT nanlilT

PERFORM BALANCE
PROCESSING

REPORTS

UNBALANCED BILLS
REPORT

Duplicates Report
Current and History

Duplicates Report
Bill Number vs History

EXPORT FILES

EXPORT

TRANSACTIONS

MAINTAIN TABLES

MAINTAIN TABLES

jLast Report

File Edit View Insert Format Records Tools Window Help MAINTAIN REPORTS IBO FORMS IMPORT STANFINS S]_xJ

# ^ Exit *o % M ◄ ► H P M % ik Qlzill ^ V 1 = ^ Filter Excluding Selection ^|]

File Edit View Insert Format Records Tools Window Help MAINTAIN REPORTS IBO FORMS IMPORT STANFINS

^ ' r Exit K'T 1%) M ◄ ► H ^ ^ *;" B a 51 'V&Z.'* Filter Excluding Selection ^

THESE BILLS ARE NOT BALANCED!!

YOU MUST FIX THEM BEFORE YOU CAN PROCEED

Print

Form

BillNoAMT

DTLCount BilINo

FileNarne

0

—

=

Balanced
IN OUT

Record: H I 1 1 T I ►! 1 I of 1

Microsoft Access - [FS TOTAL]

BiUNo

BiDNoAMT

OrigData

DUPLICATE INTER! UND BILLS
Not Processed Far Current or History Fies

Thiisday, Feb wary 01, 2001

Seller

DIC DODAAC

AM OUNT FileName

DUP DUP
Current History

SET

n □

^ Microsoft Access - [BILL SPECIAL99 : Form]

File Edit View Insert Format Records Tools Window Help MAINTAIN REPORTS IBO FORMS IMPORT STANFINS

l-l*H

# §1 Exit *o % M ◄ ► M \A zi li V y= B Filter Excluding Selection "§]

INTERFUND PR'

11 1 1 . ( i i 1 rp

1 ll|l HI 1 1 HI U| If 1 1| tt

| SELECT DATA FILE |

Clean up

1 1 iBiowseJ I

—

Clean up all files
for next

processing. All
data will be lost!!!

ii i 1 it li „ J.i li 01 1 1 i ii 'i rnii li

i i ;i i ill nuifHJ i in i i hi i

iiii li f ii

SELECT WHAT YOU WANT TO DO

1

ENTER DAMES
DOWNLOAD DATE
MM/DD/YY

1/31/011
—

Bill Number

Close Access

V I

REVERSE A BILL
RESUBMIT A BILL

II I ! I II I

.

fir i ill mi i li .^rtniL ft.ii H i

u «i mfifrm it fit 1 1 fiiii i \' \ i . fly H f j p pH

JuraMW i|, iiu i l.i i m li

Import and Process

Pick All the DAMES Files you wish to import by

Close Form clicking on browse button next to that line.

Select "Import and Process" to
, Process this file.

If I; III i It r iif: 1 1 1 in

I D ,i :iii i i I
in turn li It I ii u.

mm \\

in I iii

H r n I

fr'llLli Will

Iii

r it ml Ilf

iii * rv.f.i

Ti filnlm

if I

I 1 I I iNUMl r

Select a Different File to Import

File Edit View Insert Format Records Tools Window Help MAINTAIN REPORTS IBO FORMS IMPORT STANFINS

# IE Exit »0 ^ ^ M ◄ ► M H, M \ tit Bl zl aI ^ ^ Filter Excluding Selection T gj]

Bill «

BillAmt

DIC RIC FC DODAAC YMM: if NOT CHECKED THEN SELECT APPN

Control #

f pnpm [fg~j|22

A001 7W31 G3HFS1 B641 01 000067983

Buyer APPN/Match Valid Appropriations

[l“ |97X493QAC27

97X493QAC27

Original FS FS1 00297X4930AC6FB64 W33K09101 A0017W31G3H FG97X4930AC27000067963

SEND TO:

r ISB

r STANFINS.

r ccss 1

W Other

M

SEND TORE AD Y

r

isb r

APC

1

r

r

STANFINS r

EOR

r~

r

(•

CCSS

FC

Ffg-

r

r

r

Other

None

FY

n -

r

Record: 14 | | |~

Bill # BILLS DIC

| DODAAC Buy

1 1

DOC #

pamr

-342 fFL2 [B64~ ["

W33K09 I W33K091 01

FL2B64

Original Detail

W33K091 01 W31G3H FGA0017 000000342

1 ► I H | | of 2

r

E

DocHbr

Eo:| Eo:

[APCl APPH

rr

0

00000000000000

26 FB

NC56 2102020

n

9

1AU399

26 EE

NC53 2192020

AXW MASTER FILE EXTRACT

APC

| F| APPH

Remark

dk

2Q2C

3D40

0 2102010

SSI-RR DRESS BLUES

W0U6AA

W0U6AA

0 2102070

SUPPLEMENTAL CLOTHING (5059)

^Record: 14 |

_ll 1 ► In

1 !► + ! of 4324

1 ► | ►! |»»| of 448

FileName: 004_MSGS.txt FC MATCH T | BALANCED IN: Iy OUT: W \

MOVE

^ | ► | Refresh

DETAIL RECORDS FOR TOTAL RECORD ABOVE

FC

SC

FG

jJjJ

Record: 14 | | [

Both

I 1 I I [NUMl r

Summary & Questions